UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SOwPGVGqAow2iCSFPe3s/dBKabS1ZnfC9Mh8prdMzAo='
WHERE
key_id = 'ec6075dfb1555f8d7b2d276d3c15265a5b26d73ac2bb8cd9142a5958d056dded'
AND (
token = 'SOwPGVGqAow2iCSFPe3s/dBKabS1ZnfC9Mh8prdMzAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)