UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LqN3fgjPNsFyoDpUaEe6Ujj+UK4CP8rG+exzMxC67mU=' 
WHERE 
  key_id = '57b66010e5bef7e227b2aafc4b5b50caa404693026dbea1f847ded6f4e95c48a' 
  AND (
    token = 'LqN3fgjPNsFyoDpUaEe6Ujj+UK4CP8rG+exzMxC67mU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030