UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjtCVRgxB3CiRGCi1IymUXTRoX9T7wTAh7+aBbqzlIs='
WHERE
key_id = 'cb8717c51f8cca6ca3aefb74e62e63f7d6c859cec630224d6055f00afedf9e28'
AND (
token = 'ZjtCVRgxB3CiRGCi1IymUXTRoX9T7wTAh7+aBbqzlIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)