UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yiI8o+JJdeH00VFk914NYv6SY3LKWB+G4jfIGxrn2Yw='
WHERE
key_id = '2b80b8709ef3847efcd98664eb5a1a6ded9ed29e9d19513b96756b473c1a7d86'
AND (
token = 'yiI8o+JJdeH00VFk914NYv6SY3LKWB+G4jfIGxrn2Yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)