UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '59fhWx9//McLv39ToHaA9yPPuXcHyi8sz2CSshUZDOE='
WHERE
key_id = '3ac1cd6aa83d5f4b6d59fa94c98cb255b81e8bcfb136e50dd36c9d40ea6583d3'
AND (
token = '59fhWx9//McLv39ToHaA9yPPuXcHyi8sz2CSshUZDOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)