UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dQr7gLMYiToAAifnr7v/eStCjkSx+ep3bleu2F0OFGQ='
WHERE
key_id = '5e2165834aed4f3e9f8143f9ebfa56808f3c03234e8a0a6f9c9a2a64debcc1cb'
AND (
token = 'dQr7gLMYiToAAifnr7v/eStCjkSx+ep3bleu2F0OFGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)