UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRtJCvRDoQFbFPQnArNqBAedp7JR95DmEe10OU82+Yk='
WHERE
key_id = '8e347977a95fa4062542aa2a7dee21e327125d68711d9216a06bf602a218a6a5'
AND (
token = 'xRtJCvRDoQFbFPQnArNqBAedp7JR95DmEe10OU82+Yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)