UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rjuOySo+t/ayIl/3I3CYXWrNNTOvkN7d1Bv9SvZ+P+4=' 
WHERE 
  key_id = '43a0edbeeeb5f4e46f9487c2e09f78ac04b9bd74f276fc3a3dd8749e9b6e91e9' 
  AND (
    token = 'rjuOySo+t/ayIl/3I3CYXWrNNTOvkN7d1Bv9SvZ+P+4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032