UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tim1VQvXCX2MoP7XaKJCfQ1LXTz8qnQA+o3wVFpaeok='
WHERE
key_id = '87649e928077d67ecfed2dab02922eae78c210195d085f83d39a25aeccbb0052'
AND (
token = 'Tim1VQvXCX2MoP7XaKJCfQ1LXTz8qnQA+o3wVFpaeok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)