UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xbY7efqGsLN8oBYMnorRkSVLppNX/OrZfy7j866Xvu4='
WHERE
key_id = '3fa7f69c5a7489673ced7cf48b0a5b22219853c45ecee5b213622efa1e3bf898'
AND (
token = 'xbY7efqGsLN8oBYMnorRkSVLppNX/OrZfy7j866Xvu4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)