UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hcjppbEHV+absBxfv7+MIuTFXdZTzF4cEvUeoEG1LkU='
WHERE
key_id = 'ede3b6f9ccf76c9f112f4dcc296630da3a1fac43a25a830e66c3149fd986427d'
AND (
token = 'hcjppbEHV+absBxfv7+MIuTFXdZTzF4cEvUeoEG1LkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)