UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'woWcNZaMDZxfMMapY6yMxEsVIHLvlanLBj6Gj70zdY4='
WHERE
key_id = '0bc42f3e37f52746328637a1ae64043dd7fc0dec7ca6a84ed77f47c1013c9eed'
AND (
token = 'woWcNZaMDZxfMMapY6yMxEsVIHLvlanLBj6Gj70zdY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)