UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J95o5aSy96aJ805ZVXyCBKQq3H9o1H4pM+Jj/Q33pa8='
WHERE
key_id = '3d0e0075b869637e596948ed80b53dc788f7fee2122f5ae6bcc696aa678cd605'
AND (
token = 'J95o5aSy96aJ805ZVXyCBKQq3H9o1H4pM+Jj/Q33pa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)