UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/I3ZDc+Rac8jBPXHZabtb2wI9cHyCA8025Y8DQbZvE8='
WHERE
key_id = 'cd7fdf5c10aeebb2c51a9d807c93f5d6c350a90911ca44d81439631af1604f24'
AND (
token = '/I3ZDc+Rac8jBPXHZabtb2wI9cHyCA8025Y8DQbZvE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)