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