UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QVv6UVo1IBy82McdJ186XqMNHgpupPDq091OXck/eGE='
WHERE
key_id = '3ca590d79577db8b5040ee2b37e58f2b38caf8dfc822dd13660d387a9ccce4aa'
AND (
token = 'QVv6UVo1IBy82McdJ186XqMNHgpupPDq091OXck/eGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)