UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XGFba3xajhxCBucXIgkl7fswVvcobk9AMYe/pVxn/rs='
WHERE
key_id = 'bd53f1347ee16b00b3f98da69873c50d5e795e3a2db1e8ecfac683fe7a938dde'
AND (
token = 'XGFba3xajhxCBucXIgkl7fswVvcobk9AMYe/pVxn/rs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)