UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Frd41PnYCqmjgmiN4oF+szCqvZ0kepHTmnuCFq3goU='
WHERE
key_id = '0596c51873fd1861f70f0fc7f8aa489b0660591b47408b630b45f9dde24c9342'
AND (
token = '6Frd41PnYCqmjgmiN4oF+szCqvZ0kepHTmnuCFq3goU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)