UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5VmcZqaIT4B2a8DSYV35bmA3FToZVsX8vSHa5KLlRe4='
WHERE
key_id = 'a265721111aa3b7592aec42a09d486c395a424b431b53d6ec085242ed4360d7d'
AND (
token = '5VmcZqaIT4B2a8DSYV35bmA3FToZVsX8vSHa5KLlRe4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)