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