UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Jua7RwiSOnbDpTa4Wx5l2JtKHc0AUq0J/sMXUK18iY='
WHERE
key_id = '1ac312469517e31385677db0149b50656b798ff1282628c7173fb68d7197be7e'
AND (
token = '0Jua7RwiSOnbDpTa4Wx5l2JtKHc0AUq0J/sMXUK18iY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)