UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aSzdDp9QGZYw5Cc64581+Vd0cKMuIzAa9s1joSDrYls='
WHERE
key_id = 'fb30d4a3e64c918772beda288ae50f70cacf0f4b53eb839a379c10ebf590a814'
AND (
token = 'aSzdDp9QGZYw5Cc64581+Vd0cKMuIzAa9s1joSDrYls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)