UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'izf1idOgFKcwYGErs7eOgTMBFXPMk66e6jHWERdoRx0='
WHERE
key_id = 'bab4c48b519c5486f8112c709c9ce774e91ab868e53d34de8511eaff084f817a'
AND (
token = 'izf1idOgFKcwYGErs7eOgTMBFXPMk66e6jHWERdoRx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)