UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bEb4Vbe3Q7h8KJ57QrBo3lrDPosv9bDj+fjUR86eBaw='
WHERE
key_id = '457b979e5da1164bc1586701118c56c3271790f28dd5ef540e88968bacc8aa02'
AND (
token = 'bEb4Vbe3Q7h8KJ57QrBo3lrDPosv9bDj+fjUR86eBaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)