UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UXCpP5p3RarA3wWEo2c68gSeraV6HjKnct7Y0Qn46aE='
WHERE
key_id = '1e81646ea8223aebbfd36dc89140b2dc53a271fc647cb9be1b0243ad06e45922'
AND (
token = 'UXCpP5p3RarA3wWEo2c68gSeraV6HjKnct7Y0Qn46aE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)