UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wLo43IGROJ3jhDWIjHy/C7DPLaqUFh9k5fJJszLJcSE='
WHERE
key_id = 'd3827667004d2c0ddbe6f2500e5cfc9c5ff452d4e8007b4edfc63c9977680c7e'
AND (
token = 'wLo43IGROJ3jhDWIjHy/C7DPLaqUFh9k5fJJszLJcSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)