UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBnGWzZ9Vwd/xhiFD9pSeDJlz1jYJE2D3TMD7ahhsng='
WHERE
key_id = '34da3f623acc7f6ad2096c082ade69785c2e9907d1d0faac4a8189d203eded12'
AND (
token = 'zBnGWzZ9Vwd/xhiFD9pSeDJlz1jYJE2D3TMD7ahhsng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)