UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'drd8lp5IMmIdkYqk+yJMWnuBU6bXs3zb1c7+sVqAGRk='
WHERE
key_id = 'a192c95f350d2d8696e01dfffe43c83540c5c4615bf1e31c2ebfce70bf19892f'
AND (
token = 'drd8lp5IMmIdkYqk+yJMWnuBU6bXs3zb1c7+sVqAGRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)