UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3X8drq/eY0n10dHIliJi99Tg6nNiXvWahiidvSCt07s='
WHERE
key_id = '9c372d3f7248febe88b5557f2195507fb42a4f8839efe6d30b6f0456773a5177'
AND (
token = '3X8drq/eY0n10dHIliJi99Tg6nNiXvWahiidvSCt07s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)