UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jnX+8KCGcM2atuSgKi5MeeJEhAxFlvHanIVzPJLklMU='
WHERE
key_id = 'eb65c508a06524ce80d57d27296a0db082d3d7fdb7ddd313df07e6f26bfd5107'
AND (
token = 'jnX+8KCGcM2atuSgKi5MeeJEhAxFlvHanIVzPJLklMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)