UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zgzpSZ72YjqzDKVA4fjrJVvZEa35oFIOokn3EessyAc='
WHERE
key_id = '6c2e7ff42018c68759046117afada2e787f5eba42aa42373a0b8fd8e1020a227'
AND (
token = 'zgzpSZ72YjqzDKVA4fjrJVvZEa35oFIOokn3EessyAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)