UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BIByXx4FG00WV7kcWIYhthf6L+XNYfrW/17YVDOgZx8='
WHERE
key_id = 'e793e64bf3b3bada87da947d7e8e251c05dfb3cd60f250005764b11cdc308358'
AND (
token = 'BIByXx4FG00WV7kcWIYhthf6L+XNYfrW/17YVDOgZx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)