UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4cWfWP8I88SaDZet+9I11P8Wp+4NI5JdebpFf5OC7N0='
WHERE
key_id = 'e1e3ca68e2a42fe195fa4179427fb750b75d43f408717673cc023ed9a33f955d'
AND (
token = '4cWfWP8I88SaDZet+9I11P8Wp+4NI5JdebpFf5OC7N0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)