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