UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qwCA+f+hxOwvdjMgjjxwuFycazalvpYFhoUv31T7aqw='
WHERE
key_id = 'd55fc3734796fe4ec41ee57152d3357985a9d067380538ec6ba1aea6a7499f9d'
AND (
token = 'qwCA+f+hxOwvdjMgjjxwuFycazalvpYFhoUv31T7aqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)