UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z808RUdKugP5UGMS66UwDKrNyynOdYQUY+MUHN8WARg='
WHERE
key_id = 'e22efbcad14be4f8ae1fee0543ce16ee7c0eae08b826dc2e2208d64b5def5406'
AND (
token = 'z808RUdKugP5UGMS66UwDKrNyynOdYQUY+MUHN8WARg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)