UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y/8ZBTSioYQzTjqwmFvyDS6pQ10vN08YvTYDM3MmLRw='
WHERE
key_id = 'e31133301dc9be27d680371cecbc74b6c6142b6b00d528a90323bd684cf23bcc'
AND (
token = 'y/8ZBTSioYQzTjqwmFvyDS6pQ10vN08YvTYDM3MmLRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)