UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 't6BgP8JtAD0iZb9moP0bMa9uMUd4H5o7TnSxMsdDjwo=' 
WHERE 
  key_id = 'c7cdb74bb45a740bebc2b76a5654e3f26b7cc65be1b1ebae622b32548a7e59da' 
  AND (
    token = 't6BgP8JtAD0iZb9moP0bMa9uMUd4H5o7TnSxMsdDjwo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029