UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RHo8q6RTx0yiY5O9DpZ7vOPvb6HVemM9T1QdinabV2U='
WHERE
key_id = '38898e91a5f7f5498f9effda30aba1dc7700953d47597d19138f92a314a96bac'
AND (
token = 'RHo8q6RTx0yiY5O9DpZ7vOPvb6HVemM9T1QdinabV2U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)