UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HfyBI7xet5tKlS5XFMyQ2b1o0fMXk2XYsgx2WVABaE8='
WHERE
key_id = 'd84875e0ad46821b8a9749b65a6f43b0945d2907760c61544b6608c1b268e190'
AND (
token = 'HfyBI7xet5tKlS5XFMyQ2b1o0fMXk2XYsgx2WVABaE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)