UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0fUNNjmSb/TpjCOe+2Z7e6JhJDWgKfOvAgpl7ypqAqU=' 
WHERE 
  key_id = '98dedfc811d52995c0dd02e582a7cbab8e810a38c491acb6bc82c1d6f9c4b38a' 
  AND (
    token = '0fUNNjmSb/TpjCOe+2Z7e6JhJDWgKfOvAgpl7ypqAqU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026